What defines a relative cell reference?

Automatically changes when copied

Example of conditional formatting?

Setting values above 80 to green

What does conditional formatting do?

Apply formatting based on values

What is the order of operations?

Parentheses, Exponents, Multiplication/Division, Addition/Subtraction

studbud

Mastering Spreadsheets

25 termsStudBud Administration

Test your knowledge on spreadsheets and learn about cell references, functions, formulas, and chart formatting

Flashcards25 cardsFPractice quizPHost liveL

Questions 25

Answers

1
What can cell formatting NOT include?
Changing number format
Creating pivot tables
Merging cells
Changing font style
2
What do #### symbols mean?
Special character issue
No data in cell
Formula has an error
Column not wide enough
3
Can conditional formatting highlight cells?
False
Only for text
True
Only for numbers
4
What defines a relative cell reference?
Never changes when copied
Only for other sheets
Locked to specific row
Automatically changes when copied
5
How to display numbers as currency?
Convert to PDF
Rename file extension
Use =CURRENCY()
Use Format menu
6
Can charts be customized after creation?
Only by recreating
Only for titles
False
True
7
Best practice for table formatting?
Avoid using borders
Merge All feature
Apply alternating colors
Only color header row
8
Which function finds the smallest value?
=COUNT()
=MAX()
=AVERAGE()
=MIN()
9
Which function adds up cells quickly?
=SUM()
=MAX()
=MIN()
=AVERAGE()
10
What symbol indicates an absolute reference?
* (asterisk)
& (ampersand)
# (hash)
$ (dollar sign)
11
How to calculate the mean of cells?
=MID()
=COUNT()
=MEAN()
=AVERAGE()
12
Which function counts numeric cells?
=COUNT()
=LEN()
=COUNTA()
=SUM()
13
Example of conditional formatting?
Setting values above 80 to green
Applying bold text
Changing fill color
Adding color-coded tab
14
Can formulas include numbers and references?
Only numbers
False
True
Only references
15
Which is NOT a basic function?
=SQRT()
=AVERAGE()
=SUM()
=MIN()
16
Where to change chart type?
Format > Number
File > Download
Insert > Image
Chart Editor sidebar
17
Best chart for trends over time?
Pie chart
Radar chart
Line chart
Scatter plot
18
Is absolute reference adjustable when copied?
True
False
Depends on context
Always adjustable
19
Best chart for parts of a whole?
Scatter plot
Bar chart
Pie chart
Line chart
20
Which reference remains fixed when copied?
Mixed reference
None of the above
Absolute reference
Relative reference
21
How to change chart title?
Format cells to currency
Double-click chart title
Delete and recreate chart
Use conditional formatting
22
What does conditional formatting do?
Apply formatting based on values
Merge multiple cells
Calculate totals without formulas
Split one cell
23
What must every formula start with?
+ (plus sign)
= (equal sign)
@ (at)
# (hash)
24
What is the order of operations?
Multiplication, Exponents, Parentheses, Addition, Subtraction
Parentheses, Exponents, Multiplication/Division, Addition/Subtraction
Addition, Subtraction, Multiplication, Division, Parentheses
None of the above
25
Shortcut for editing cell content?
Ctrl + V
Ctrl + C
F2 or Return
Alt + Tab

Mastering Spreadsheets Flashcards | StudBud