WorksheetsExcel Ch. 2
Total questions: 18
Worksheet time: 9mins
What is a pre-written formula called?
Feature
Function
Task
Calculation
What is pressed to get a new line in a cell?
Alt+Shift
Ctrl+Enter
Shift+Enter
Alt+Enter
What is the correct order of arithmetic operations?
NSADMEP
NPEMDAS
NEPDMSA
PERMSAN
All of the following are arithmetic operators expect?
<
^
-
%
Which one of the following is an arithmetic operator?
#
<
=
*
Calculate the following formula =6*(4-2)
24
6
12
4
Calculate the following formula =2^3/2
2
4
8
12
What is point mode?
Edit contents into cells directly
Select range from a worksheet
Select cells using a mouse
Select cells using a keyboard for formula
What character must be entered first for Excel to recognize a formula?
-
=
=
+
Which is NOT in the Σ menu?
MIX
SUM
MAX
MIN
Thick box border is located under which tab?
Home
Insert
Page Layout
Formula
This is an example of what?
Cell styles
Range fill
Conditional formatting
Range finder
This conditional formatting rule will format cells with blue background and white text under what condition?
x ≤ 70
x > 70
x = 70
x < 70
Which of the following is a correct method to display a negative number?
-$1,234.56
($1,234.56)
In red
<$1,234.56>
What key must you hold to select non-adjacent cells?
Ctrl
Alt
Shift
Can't be done
What view in the status bar allows us to access the header?
Normal
Page Break Preview
Worksheet
Page Layout
What is the keyboard shortcut for the formulas page?
Ctrl + #
Ctrl + *
Ctrl + `
Crtl + ^
Select all printer settings you must use to print in Excel
Choose printer
Print Both Sides
Print Entire Workbook
Fit Sheet on One Page
Landscape Orientation
