Test 8
To display Format cells dialog box you have to press
  • Ctrl + 1
  • Ctrl + K
  • Ctrl + 2
  • Ctrl + D
Explanation: The correct answer is: a. Ctrl + 1 Pressing Ctrl + 1 will display the "Format Cells" dialog box in applications like Microsoft Excel. This dialog box allows you to format the selected cells in various ways, such as changing the number format, applying borders, and modifying font styles.
To enter the current data press
  • Ctrl + ;
  • Shift + ;
  • Ctrl + :
  • Alt + ;
Explanation: The correct answer is: a. Ctrl + ; Pressing Ctrl + ; (semicolon) is the keyboard shortcut to enter the current date in applications like Microsoft Excel. It inserts the current date into the selected cell.
Text control group of Alignment property sheet contains which of the following function
  • Wrap text
  • Shrink to fit
  • Merge cells
  • All of the above
Explanation: The correct answer is: d. All of the above In Microsoft Excel, "Wrap Text," "Shrink to Fit," and "Merge Cells" are all formatting options: "Wrap Text": This option wraps text within a cell, displaying it on multiple lines if necessary. "Shrink to Fit": This option reduces the font size of the text in a cell to fit it within the cell's width. "Merge Cells": This option combines multiple cells into one larger cell, typically used for creating headings or labels that span across multiple columns or rows.
To format characters in a sheet, use
  • Shortcut keys
  • Toolbar buttons
  • Menu commands
  • All of the above
Explanation: To format characters in a spreadsheet, you can use a combination of methods: a. Shortcut keys: Keyboard shortcuts can be used to quickly apply formatting to selected text. For example, in many spreadsheet applications, you can use shortcuts like Ctrl+B for bold, Ctrl+I for italic, and Ctrl+U for underline. b. Toolbar buttons: Most spreadsheet software includes a toolbar or ribbon with buttons for common formatting options. You can use these buttons to apply formatting such as bold, italic, underline, font size, font color, and more. c. Menu commands: Formatting options are often available in the menu bar of spreadsheet applications. You can navigate through the menus to find options for formatting characters, such as changing font styles, sizes, colors, and alignment. d. Formatting options dialog: Many spreadsheet applications also provide a formatting options dialog where you can access advanced formatting settings for characters, such as adjusting spacing, applying borders, or setting text effects. So, to format characters in a sheet, you can use any combination of these methods depending on your preference and the specific formatting you want to apply.
By, default, excel sheet display the following front style
  • Strikethrough
  • Bold
  • Italic
  • None of the above
Explanation: By default, Excel sheets display text in the regular font style, which is typically not strikethrough, bold, or italic. The default font in Excel is usually Calibri or Arial, and the text is displayed in a normal, unformatted style.
Formulas are made up of
  • Arithmetic operations such as= + - and other functions
  • Only arithmetic operations
  • Only functions
  • None of the above
Explanation: a. Arithmetic operations such as =, +, -, and other functions Formulas in Excel are composed of a combination of arithmetic operations (such as addition, subtraction, multiplication, and division) and functions (such as SUM, AVERAGE, VLOOKUP, etc.).
Once a range has been named, you can go to a range
  • By selecting ranges using the name box