COMPUTER SCIENCE - EXCEL FINAL 2024

What is the default file extension for Excel workbooks?

• XLSM

• XLTX

• XLSX

• XLS

What is a workbook in Excel?

• A single spreadsheet within a workbook

• A file that contains one or more related worksheets

• A document that stores and manipulates data in columns and rows

• A file extension for Excel workbooks

A ____________ is a set of calculations that are applied to values in a spreadsheet.

What symbols represent an Arithmetic Operator?

• *

• /

• +

• -

• All of the Above

Which cell represents an absolute reference?

• B1

• $B$1

• B$1

• $B1

Which letter on the image is a Row?

• A

• B

• C

• D

Which letter on the image is a Column?

• A

• B

• C

• D

A column in a spreadsheet can be described as:

• Horizontal cells that are labeled by letters

• Horizontal cells that are labeled by numbers

• Vertical cells that are labeled by letters

• Vertical cells that are labeled by numbers

A row in a spreadsheet can be described as:

• Horizontal cells that are labeled by letters

• Horizontal cells that are labeled by numbers

• Vertical cells that are labeled by letters

• Vertical cells that are labeled by numbers

Label the worksheet screen

g

h

i

j

c

d

e

f

b

a

namebox

row

titlebar

range of cells

scroll bars

column

active cell

quick access toolbar

sheets

formulabar