MS Excel Basics, Microsoft Excel

MS Excel Basics

Question: Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A
Pressing Ctrl +Home

B
Pressing Home

C
Pressing Shift + Home

D
Pressing Alt + Home

Note: Not available
1. Report
Question: When you copy a formula
A
Excel erases the original copy of the formula

B
Excel adjusts cell references in the newly copied formula

C
Excel adjusts absolute cell references

D
Excel doesnâ€™t adjust relative cell references

Note: Not available
1. Report
Question: Getting data from a cell located in a different sheet is called ______
A
Accessing

B
Referencing

C
Updating

D
Functioning

Note: Not available
1. Report
Question: When a label is too long to fit within a MS Excel Worksheet cell, you typically must
A
Shorten the label

B
Increase the column width

C
Decrease the column width

D
Adjust the row height

Note: Not available
1. Report
Question: Each Excel file is called a workbook because
A
It can contain text and data

B
It can be modified

C
It can contain many sheets including worksheets and chart sheets

D
You have to work hard to create it

Note: Not available
1. Report
Question: Which of the following will return the Maximum value of the cells between C19 to C29 in MS Excel?
A
=Maximum(C19:C29)

B
=Max(C19:C29)

C
=Max(C19 to C29)

D
MS Excel canâ€™t do this task.

Note: Not available
1. Report
Question: When you put a formula in a cell and the cell displays ####### ? It means ______
A
Excel does not recognize text contained in the Formula

B
A Cell reference is invalid

C
Contents cannot be displayed correctly as the column is narrow

D
Invalid Column

Note: Not available
1. Report
Question: When you enter a formula in a cell and the cell displays #NAME? It means ______
A
Excel does not recognize the text contained in the Formula

B
Invalid Column

C
Contents cannot be displayed correctly as the column is narrow

D
A cell reference is invalid

Note: Not available
1. Report
Question: MS Excel uniquely identifies cells within a worksheet with a cell name that consists of ______
A
Cell names

B
Column numbers and row letters

C
Column letters and row numbers

D
Cell locator coordinates

Note: Not available
1. Report
Question: A worksheet range is ______
A
A command used for data modeling

B
A range of values such as from 23 to 234

C
A group of cells

D
A group of worksheets

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

Question: Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Question: When you copy a formula

Question: Getting data from a cell located in a different sheet is called ______

Question: When a label is too long to fit within a MS Excel Worksheet cell, you typically must

Question: Each Excel file is called a workbook because

Question: Which of the following will return the Maximum value of the cells between C19 to C29 in MS Excel?

Question: When you put a formula in a cell and the cell displays ####### ? It means ______

Question: When you enter a formula in a cell and the cell displays #NAME? It means ______

Question: MS Excel uniquely identifies cells within a worksheet with a cell name that consists of ______

Question: A worksheet range is ______