Study

Review of Microsoft Word & Excel

  •   0%
  •  0     0     0

  • Which command in Spreadsheet or word processing allows you to replicate entries from one location to the other
    Copy
  • To center align text in a word document, you can use which of the following shortcut?
    Ctrl + E
  • The keys you are supposed to rest/return your fingers when typing are called
    Home row
  • By default, how many worksheets are loaded in Microsoft Excel (Office 365)?
    1
  • You cannot add columns and/rows to a table once it is created?
    False
  • The lines that outlines and divides boxes in a table are called
    Borders
  • The cell that is currently in use
    Active cell
  • Which of the following are the home keys
    ASDFJKL;
  • 25. Which of the following is the default addressing type is used in spreadsheet when you copy and paste formulas/functions?
    Relative cell
  • An entry in a spreadsheet cell representing test scores is most likely a
    Value
  • In a computer spreadsheet, SUM, MAX and AVERAGE are examples of a. Formulas
    Functions
  • When touch typing, your feet should be flat on the ground
    True
  • When copying a formula to another cell, which of the following cell references should be applied if you want to always refer to the same location?
    Absolute cell references
  • When ### is displayed in a cell, this is an indicator that
    The column in the sheet is too small
  • Which tab in your spreadsheet application allows you to apply formatting to text?
    Home
  • In spreadsheet, when you select a group of cells, this is called
    range
  • By default, numbers are aligned to which sided of the cell
    Right
  • Which of the following shortcut can be used to paste /replicate data
    CTRL + V
  • By default, the page orientation in word processing is landscape
    landscape
  • Which tab should you click to add a table to your Word Document?
    Insert
  • Which tab in your word processing application allows you to create tables?
    Insert
  • Formulas and functions do not begin with an equal sign
    False
  • You cannot wrap text around images
    False
  • If you input the formula in your spreadsheet = (7 – 4) x (2 + 8) / 2 is
    15
  • Which part of the excel window displays the name of the file?
    Title bar
  • In a spreadsheet, letters are used to represent
    Columns
  • Which term refers to the intersection between rows an columns in a spreadsheet?
    Cell
  • Related commands that are group together on the ribbon are called?
    Command groups
  • Where should your eyes be when keyboarding
    Looking at the copy (what you need to type)
  • When keyboarding in class, you should focus on
    Accuracy
  • In a spreadsheet application, which symbol is used to represent absolute references.
    $