ALS 2nd Qtr Exam in EmpTech

Which shortcut key is used to save your spreadsheet progress?

• CTRL + S

• CTRL + N

• CTRL + O

• CTRL + C

What is the purpose of renaming Sheet1 and Sheet2 as “Income” and “Expense”?

• To delete unnecessary data easily

• To identify the purpose of each tab clearly

• To hide confidential information

• To make the file smaller in storage

How can you adjust the width of a column in a spreadsheet?

• Use the Insert Tab and add new rowS

• Double-click on the sheet name area

• Click and drag the column heading edge

• Right-click and press the Delete button

Which command sequence aligns and bolds the text in selected cells?

• A. File > Save, then Review > Check

• B. View > Sort, then Home > Italic

• C. Insert > Chart, then Home > Wrap

• D. Home > Center, then Home > Bold

Why do you need to format the cells as “Currency” with the Peso sign (₱)?

• To convert the figures automatically into percentages

• To indicate that the data represent monetary values

• To hide the numerical values from the table view

• To reduce the number of digits displayed in the cells

When you use the formula =SUM(C2:C3) in cell C4, what does it compute?

• The average of all cells in the column

• The product of all numbers in C2:C3

• The difference between C2 and C3

• The total of values from C2 to C3

What could be the consequence of not formatting the table using “Table Style Light 9”?

• The chart will stop updating automatically

• The worksheet will fail to calculate totals

• The table may appear plain and harder to read

• The cells will automatically delete the content

Why should you use formulas like =Income!C4 or =Expense!C12 in the Report Summary tab?

• To hide the formulas from other users of the file

• To create a backup copy of the spreadsheet file

• To automatically link and update values from other tabs

• To make manual encoding of data faster and easier

When making the FINANCIAL SUMMARY PIE GRAPH, which step ensures clarity of presentation?

• Renaming the chart title appropriately

• Removing all data labels from the pie chart

• Combine all income and expenses in a single list without formulasChanging the worksheet background color

• Converting the chart into a stacked bar type

If you were to design Jose’s Budgeting Spreadsheet, what is the best way to summarize his financial data?

• Type the total values manually in each cell to save time

• Use only text labels instead of numerical data for easy viewing

• Combine all income and expenses in a single list without formulas

• Create Income and Expense tabs and use a Summary tab with formulas and chart