ICDL Spreadsheets (ICDL Foundation)

A colleague needs to import spreadsheet data into a database system that accepts only raw, comma-separated plain text. Which file format should you use to save the spreadsheet?

• AExcel Workbook (.xlsx)
• BCSV (Comma Delimited) (.csv)
• CExcel Template (.xltx)
• DPDF Document (.pdf)

You are creating a monthly sales report layout that will be reused by regional managers who must enter new data each month without altering the base structure. What is the best file format for this master file?

• AExcel 97-2003 Workbook (.xls)
• BExcel Template (.xltx)
• CPDF Document (.pdf)
• DCSV (Comma Delimited) (.csv)

Which element of the Excel user interface displays the contents of the active cell and allows you to enter or edit formulas?

• AStatus Bar
• BRibbon
• CQuick Access Toolbar
• DFormula Bar

What is the primary benefit of customising the Quick Access Toolbar in Excel?

• AIt provides single-click access to frequently used commands regardless of which Ribbon ta…
• BIt increases the calculation speed of complex formulas in the workbook.
• CIt automatically hides formulas from users who do not have permission to view them.
• DIt prevents Excel from crashing when handling very large datasets.

A user is unsure how to use a specific function and wants to find official help documentation within Excel. Which standard keyboard shortcut opens the Help pane?

• AF5
• BF7
• CF1
• DF11

Which statement correctly describes the effect of changing the Zoom level in Excel?

• AIt permanently alters the font size of the text within the selected cells.
• BIt automatically resizes column widths to prevent text truncation.
• CIt changes the size of the worksheet display on your screen but has no effect on the prin…
• DIt scales both the screen display and the printed output proportionally.

You want to protect a sensitive financial workbook so that unauthorized users cannot open it to view the contents. Which method should you use?

• ASave the workbook with an Encrypt with Password security setting.
• BHide all the worksheets in the workbook.
• CSet the file attribute to Read-Only in the file properties.
• DFormat all cell contents with white text on a white background.

Your computer suddenly loses power while you are working on an unsaved Excel workbook. What feature helps recover your lost work when you restart Excel?

• AAutoSave
• BUndo History
• CAutoRecover
• DTrack Changes

What is a major limitation of saving a modern Excel workbook in the older Excel 97-2003 Workbook (.xls) format?

• AIt reduces the maximum grid size to 65,536 rows and may disable newer formulas and format…
• BIt converts all formulas into static values permanently.
• CIt prevents the file from being opened by any newer version of Excel.
• DIt automatically compresses the workbook into a ZIP archive, requiring decryption.

Which menu command or shortcut should you use to close only the active workbook without closing the entire Excel application?

• AClick the 'X' button in the upper-right corner of the Excel application window
• BPress Alt + F4 on the keyboard
• CSelect File > Exit
• DClick File > Close or press Ctrl + W

You select a range of cells containing numeric values. By default, where can you quickly check summary statistics such as Sum, Average, and Count without writing any formulas?

• AQuick Access Toolbar
• BFormula Bar
• CStatus Bar
• DName Box

Which keyboard shortcut allows you to quickly cycle and switch between multiple open workbooks in the active Excel session?

• ACtrl + Tab
• BAlt + Tab
• CCtrl + Page Down
• DShift + Spacebar

What is the purpose of the Search / 'Tell Me' box located at the top of the Excel ribbon?

• AIt acts as a search engine for finding external data on the internet.
• BIt finds and replaces specific text within your active worksheet cells.
• CIt allows you to search for commands, find help articles, and execute actions directly.
• DIt is a chat tool for communicating with other collaborators in real time.

What is a key security and reliability advantage of saving your Excel workbooks to cloud storage locations like OneDrive or SharePoint compared to local storage?

• AIt automatically locks the file to make it read-only for all users permanently.
• BIt disables formula auditing tools to protect intellectual property.
• CIt enables real-time collaboration with automatic version history to restore previous rev…
• DIt prevents the file size from exceeding 1 megabyte to ensure fast load times.

You accidentally delete a worksheet containing valuable data from your active workbook. Which of the following is true?

• AYou can instantly restore the worksheet by pressing Ctrl + Z.
• BThe sheet is moved to the Excel Trash folder, where it can be recovered within 30 days.
• CThe deletion is permanent and cannot be undone using the Undo action; you must close with…
• DExcel automatically re-creates the deleted worksheet using the AutoRecover log.

When you enter standard text and raw numbers into unformatted Excel cells, what is their default horizontal alignment?

• AText aligns to the right; numbers align to the left.
• BText aligns to the left; numbers align to the right.
• CBoth text and numbers align to the center.
• DText aligns to the left; numbers align to the center.

Which key must you hold down while clicking cells to select multiple non-adjacent cells or cell ranges in Excel?

• AShift
• BCtrl
• CAlt
• DTab

You copy a range of cells containing formulas. You want to paste only the calculated numerical results into another sheet without keeping the formulas or formatting. Which option should you choose?

• APaste Special > Formulas
• BPaste Link
• CPaste Special > Transpose
• DPaste Special > Values

You have entered a formula in cell C2. What is the fastest way to copy this formula down to column C to match the height of your data in column B?

• APress Ctrl + Shift + Down Arrow, then press Ctrl + V.
• BDrag the mouse manually from cell C2 down to the bottom of the worksheet.
• CSelect cell C2, right-click, and select 'Copy to All Rows'.
• DDouble-click the Fill Handle (small green square) in the bottom-right corner of cell C2.

You want to sort a table of sales reps by their total sales. You select only the Sales column and click Sort. Why does Excel warn you to 'Expand the selection'?

• AExcel requires you to format the column with gridlines before sorting.
• BSorting only the selected column will scramble the data, separating the sales figures fro…
• CThe software must expand the selection to include empty cells at the bottom of the worksh…
• DExpanding the selection is necessary to convert formulas in the column into values.

You want to replace every occurrence of the word 'Dept' with 'Department' in your active sheet. Which feature should you use?

• AAutoFilter
• BFind and Replace (Ctrl + H)
• CData Validation
• DSpell Check (F7)

You want to enter inventory ID codes like '00789' into a column. When you type it, Excel automatically removes the leading zeros, displaying '789'. How can you prevent this?

• AType an apostrophe (') before the number, or format the cell range as 'Text' before typin…
• BFormat the cell range as 'Currency'.
• CAdd a decimal point at the end of the number.
• DTurn off the Excel AutoCorrect feature.

Which keyboard shortcut allows you to select the entire column containing the active cell in Excel?

• AShift + Spacebar
• BCtrl + Spacebar
• CCtrl + Shift + Down Arrow
• DAlt + Page Down

You have a list of months arranged vertically in a column, but you need to display them horizontally across a single row. What feature should you use?

• AUse Find and Replace to rearrange the cells.
• BApply Wrap Text formatting to the column range.
• CUse the AutoFill handle to drag the column sideways.
• DCopy the data, then use Paste Special > Transpose.

When using Excel's Find tool, what wildcards can you use to search for characters, and what do they represent?

• AAn exclamation mark (!) matches any number, while a hash (#) matches letters.
• BA percent sign (%) matches formulas, while an ampersand (&) matches text values.
• CA dollar sign ($) matches currency values, while a backslash (\) matches folder paths.
• DAn asterisk (*) matches any sequence of characters, while a question mark (?) matches exa…

By default, what actions occur when you press the 'Enter' key versus the 'Tab' key after typing data into a cell?

• AEnter clears the cell contents; Tab saves the workbook to the local drive.
• BEnter confirms the entry and moves the selection down; Tab confirms and moves the selecti…
• CEnter moves the selection to the right; Tab moves the selection down.
• DEnter opens the Help menu; Tab inserts a blank row above the current cell.

Which keyboard shortcut highlights all cells from your active cell to the very last populated cell in that row?

• ACtrl + End
• BAlt + Shift + Page Down
• CCtrl + Spacebar
• DCtrl + Shift + Right Arrow

You want to sort a list of employees by their shift days (Monday, Tuesday, Wednesday, etc.) rather than alphabetically. Which sorting option should you use?

• ASort A to Z
• BCustom List Sort
• CSort Z to A
• DConditional Sort

What is the difference between pressing the 'Delete' key on your keyboard and using the 'Delete' command in the Home tab menu on a selected cell?

• AThe Delete key deletes the whole worksheet; the Delete command deletes only one cell's te…
• BThe Delete key removes cell borders; the Delete command clears only formula links.
• CThere is no difference; both perform the exact same cleanup operations.
• DThe Delete key clears the cell's content but leaves the empty cell in place; the Delete c…

You type 'January' in cell A1 and drag the Fill Handle downwards. What does Excel generate in the cells below?

• ARepeated copies of the word 'January' in every cell.
• BA series of consecutive months: February, March, April, etc.
• CAn alphabetical list starting with 'April', 'August', 'December'.
• DExcel displays a #VALUE! error because 'January' is not a number.

You select row 5 in a worksheet, right-click the row header, and choose 'Insert'. Where does the new row appear, and what happens to the existing row 5?

• AThe new row appears directly above row 5; the existing row 5 and all rows below it are sh…
• BThe new row appears directly below row 5; row 5 remains unchanged.
• CThe new row replaces row 5, deleting its original contents permanently.
• DThe new row is appended to the very bottom of the worksheet grid.

After entering a large number into a cell, the cell displays '###' instead of the number. What does this indicate, and how do you resolve it?

• AThe cell contains a formula error; delete the cell contents and start over.
• BThe column is too narrow to display the formatted number; increase the column width.
• CThe number is negative; format the cell to display negative values.
• DThe workbook is corrupted; save and restart the application.

What is the standard method to rename an active worksheet tab at the bottom of the Excel window?

• ASelect File > Save As and type the new sheet name.
• BClick the Name Box in the formula bar and enter the sheet name.
• CDouble-click the sheet tab, type the new name, and press Enter.
• DPress the F2 key while selecting any cell inside the worksheet.

You want to copy a worksheet named 'Q1_Sales' from your current workbook to another open workbook named 'Annual_Report'. What is the safest way to do this?

• ADrag the sheet tab to the 'Annual_Report' file tab on the desktop.
• BUse copy-paste (Ctrl + C and Ctrl + V) on the sheet tab itself.
• CRight-click the 'Q1_Sales' tab, select 'Move or Copy', choose 'Annual_Report' as the dest…
• DExport the sheet as a PDF and import it into the destination workbook.

Which Excel feature keeps specific rows or columns visible at the top or side of the screen while you scroll through the rest of the worksheet?

• ASplit Window
• BArrange All
• CFreeze Panes
• DHide Columns

You want to freeze both Row 1 (header row) and Column A (employee names) at the same time so they remain visible while scrolling. Which cell must you select before clicking 'Freeze Panes'?

• ACell A1
• BCell B2
• CCell B1
• DCell A2

You need to delete Columns C, D, and E from your worksheet. What is the most efficient method?

• ASelect cell C1, press the Delete key, and repeat for D1 and E1.
• BHide Columns C, D, and E using the Format menu.
• CDelete the data in each cell manually using the Backspace key.
• DDrag select column headers C, D, and E, right-click the selection, and select 'Delete'.

Column B in your worksheet is hidden. How can you make Column B visible again?

• ADouble-click the header of Column A.
• BSelect Column A, then press Ctrl + Z.
• CSelect column headers A and C, right-click the selection, and select 'Unhide'.
• DGo to File > Options and click 'Restore Hidden Gridlines'.

You try to delete a worksheet that contains data. What warning does Excel display, and what is the consequence of proceeding?

• AExcel warns that the workbook will become read-only for all users.
• BExcel warns that all formulas in other worksheets will be deleted.
• CExcel asks you to set a password before deleting the worksheet.
• DExcel warns that you cannot undo this action; if you proceed, the sheet and its data are…

What is the purpose of changing the tab color of different worksheets in a large workbook?

• ATo visually organize and categorize different worksheets for easier navigation.
• BTo indicate that the worksheet is locked and cannot be edited.
• CTo change the background color of all cells in that worksheet.
• DTo prevent the worksheet from being printed.

What is the fastest way to adjust a column's width so that it fits the longest entry in that column?

• ARight-click the column header and choose 'Format Painter'.
• BDouble-click the boundary line on the right side of the column header.
• CDrag the column header border manually to the right margin of the screen.
• DSelect the column and press Ctrl + Shift + W.

You want to insert three new blank worksheets into your workbook at the same time. How can you do this efficiently?

• AHold Shift, select three existing worksheet tabs, right-click, and select 'Insert' > 'Wor…
• BDouble-click the '+' icon at the bottom of the screen three times rapidly.
• CSelect File > New > Sheets and choose 'Three Blank Worksheets'.
• DPress Ctrl + Shift + N three times on the keyboard.

What is the primary difference between the 'Split Window' feature and the 'Freeze Panes' feature in Excel?

• ASplit hides gridlines in the active worksheet; Freeze locks cell editing.
• BSplit divides the window into separate scrollable areas; Freeze locks specific rows or co…
• CSplit saves the worksheet as a new file; Freeze protects the workbook with a password.
• DThere is no difference; they are different names for the same feature.

Gridlines are visible on your screen, but they do not print when you print the worksheet. How can you make gridlines print?

• ADraw borders manually around every cell in the worksheet.
• BIn the Page Layout tab, under Sheet Options, check the 'Print' box under Gridlines.
• CChange the gridline color to black in the Excel Options menu.
• DFormat the entire worksheet as a table.

You want to move a worksheet tab to a new position along the sheet bar. What is the easiest way to do this?

• AClick and hold the sheet tab, drag it left or right to the new position, and release the…
• BCut and paste the sheet tab using Ctrl + X and Ctrl + V.
• CUse the Rename command to change the sheet's index number.
• DDouble-click the sheet tab and type its new position number.

What is the result of the formula =(10 - 2) * 3 + 4 in Excel?

• A20
• B14
• C28
• D38

Cell C1 contains the relative formula =A1+B1. If you copy cell C1 and paste it into cell C2, what formula will cell C2 contain?

• A=A1+B1
• B=A2+B1
• C=A2+B2
• D=$A$1+$B$1