Question

Spreadsheets are organized into _____ and _____.

(1 point)
Responses

binary; decimal

binary; decimal

data; information

data; information

rows; columns

rows; columns

computation; argumentationIf a column will contain prices of smartphones, which number format should be used?

(1 point)
Responses

accounting

accounting

data

data

currency

currency

moneyCells in a spreadsheet are named by their:

(1 point)
Responses

data type.

data type.

variable type.

variable type.

column number and row letter.

column number and row letter.

column letter and row number.Businesses often use _____ to create reports, budgets, and tables.

(1 point)
Responses

social media software

social media software

scheduling software

scheduling software

systems software

systems software

spreadsheetsWhich of these is an example of the default date format in Google Sheets?

(1 point)
Responses

April 4, 2023

April 4, 2023

4 April 2023

4 April 2023

4/4/2023

4/4/2023

04/04/2023Claudio combines six cells into one in a spreadsheet but then decides that he needs to undo it. Which button does he need now?

(1 point)
Responses

Decenter

Decenter

Merge

Merge

Unmerge

Unmerge

AlignWhat will the formula =SUM(J2:J10) do?

(1 point)
Responses

add the values in the J row

add the values in the J row

add 2 and 10, and put the sum in the J column

add 2 and 10, and put the sum in the J column

add the values in cells J2 through J10

add the values in cells J2 through J10

add the values and put them in cell J2, J10

Answer 1

Here are the correct responses for each question:

1. Spreadsheets are organized into **rows; columns**.
2. If a column will contain prices of smartphones, which number format should be used? **currency**.
3. Cells in a spreadsheet are named by their: **column letter and row number**.
4. Businesses often use **spreadsheets** to create reports, budgets, and tables.
5. Which of these is an example of the default date format in Google Sheets? **4/4/2023**.
6. Claudio combines six cells into one in a spreadsheet but then decides that he needs to undo it. Which button does he need now? **Unmerge**.
7. What will the formula =SUM(J2:J10) do? **add the values in cells J2 through J10**.