Excel Basics Quiz Cameron

Which Excel function is used to add together the values in a specified range of cells?

• COUNT

• SUM

• DIVIDE

• MIN

Tags

DOK Level 1: Recall

How would you apply a green fill color to cells with values above 100 using conditional formatting in Excel?

• Manually change the color of each cell above 100

• Use a formula to determine which cells are above 100 and then color them

• Select "Highlight Cell Rules" > "Greater Than..." and set the value to 100 and choose green color

• Write a macro to automatically detect and color the cells

Tags

DOK Level 2: Skill/Concept

In Excel, which function would you use to find the lowest number in a range of cells?

• MIN

• MAX

• AVERAGE

• SUM

Tags

DOK Level 1: Recall

What does the `$` symbol signify when used in a cell reference like `B$3` in Excel?

• It is used to denote text formatting

• It locks the row number in the reference

• It signifies a mathematical operation

• It is a placeholder for data input

Tags

DOK Level 2: Skill/Concept

How can you sort data in Excel from highest to lowest?

• Use the "Sort & Filter" button on the "Home" tab and select "Sort Descending"

• Manually move the rows to arrange them from highest to lowest

• Write a formula to rearrange the data

• Use the "Data" tab and select "Filter"

Tags

DOK Level 1: Recall

Provides Information about the Document

• Status Bar

• Ribbon

• Formula Bar

• Document Properties

Cell reference changes when copied or filled

• Relative Cell

• Absolute Cell

• Mixed Reference

• Cell Style

What function in Excel would you use to calculate the value of a range of cells?

• SUM

• COUNT

• AVERAGE

• MAX

What does the `:` symbol signify when used in a cell range like `A1:A10` in Excel?

• It is used to denote a single cell

• It signifies a mathematical operation

• It specifies a range of cells

• It is a placeholder for data input

What type of charts can be created in Excel? (check any and all that apply)

• column

• line

• pie

• statistical