NEW
Font size
WorksheetsExcel 2016
Total questions: 20
Worksheet time: 10mins
If you want to compare parts to the whole, which type of graph/chart would work the best?
Pie
Bar
Column
Line
Which of these will you find on the AutoSum dropdown menu?
All of them
MUL
DIV
SUM
Which of the following is considered a range in Excel?
9B:30C
A1:B8
A1, C22, D14
They are all ranges
Clicking this icon after selecting the range, will result in all selected cells merging into one larger cell.
Merge and Center
Center
Wrap Text
FlashFill
Which of the following is the Name Box?
A
B
C
D
Which of the following is a row?
A
B
C
D
Which of the following is a column?
A
B
C
D
What is the address of this cell?
B3
3B
AB3
None of them is correct
Where do your formulas appear when you type them in a worksheet?
Name Box
Formula Bar
Search Box
Function Bar
Which one of these icons will increase decimal places?
A
B
C
D
What is the arrow pointing to?
Add a New Sheet Tab
Document Tab
Sheet Tab
Slides Tab
Which symbol is placed at the beginning of a new formula in Excel?
=
+
-
/
Which of these icons will decrease decimal places?
A
B
C
D
If you want Excel to treat a number like text, which symbol must you add in front of the number?
' (apostrophe)
^ (caret)
! (exclamation point)
* (asterisk)
This mouse pointer will _____.
Allow you to copy contents of the cell
Allow you to drag and drop contents of the cell
Allow you to select multiple cells
Allow you to delete contents of the cell
This mouse pointer will allow you to _____.
Copy contents of the cell
Select multiple cells
Delete contents of the cell
Drag and drop contents of the cell
This mouse pointer will allow you to _____.
Copy contents of the cell
Select multiple cells
Drag and drop contents of the cell
Delete contents of the cell
This mouse pointer allows you to _____.
Widen or decrease the width of the column
Delete the column
Insert a new column
Widen or decrease the height of a row
This mouse pointer allows you to _____.
Change the height of an entire row
Delete an entire row
Select an entire column
Select an entire row
Which type of chart is best suited to comparing data?
Pie
Bar or Column
Line
Scatter
