Study

MS Excel Game 2

  •   0%
  •  0     0     0

      Back   Restart
  • In MS Excel, how Bold, Italic, and Underline are applied to the text or data? Remember the key word.
    Highlight the cells and click B, I, or U for Bold, Italic, and Underline respectively.
  • Can you form ONE WORD with the following letters? T-E-E-H-S-K-R-O-W
    WORKSHEET
  • List at least 2 functions or formulas we learned today in MS Excel.
    SUM,AVERAGE, MAX, MIN, COUNT, AVERAGE, LEN, ADDITION OPERATION, ...
  • Name at least 1 tool used in VBA or MS Excel Programming/Coding
    CommandButton, OptionButton, CheckBox, Label, TextBox, ListBox, DropBox,..
  • Which of the following represents a cell in MS Excel? 1C5, 15C, A15, CC, AA
    A15 is a cell. A cell has the column before the row.
  • What is the difference between "Portrait Orientation" and "Landscape Orientation"
    Landscape images are captured in a horizontal layout while portrait images are captured in a vertical layout.
  • One method to create table in MS Excel. Remember the key word in your answer.
    HIGHLIGHT the data and choose "All Borders" in the Ribbon. Or, HIGHLIGHT the data and choose "Format Cells" from the Ribbon or from the right click menu.
  • For typing practice, what fingers we use for letters F and J?
    Left hand index for the letter F and right hand index for the letter J.
  • Find the 4 missing letters to complete the word. "_PER_T_O_S"
    The missing letters are: O, A, I, N The word is "OPERATIONS"
  • Open MS Excel worksheet, and write a simple formula to list the first 10 odd numbers.
    Your teacher will check your work.
  • How to recognize the formula bar in MS Excel?
    The long bar on top of columns or fx bar.
  • In the "Ribbon" what B,I, and U are used for?
    B is for Bold, I for Italic. and U for Underline.
  • Open MS Excel worksheet, and write a simple formula to list the first 10 counting numbers.
    Your teacher will solve this question in MS Excel.
  • What language did we use in MS Excel Programming/Coding
    VBA = Visual Basic for Applications
  • What is the main difference between these TWO formulas. =AVERAGE(A1 : E1) and = AVERAGE(A1,E1) ?
    =AVERAGE(A1 : E1) used the values from cells A1 through E1, whereas =AVERAGE(A1,E1) used the values in A1 and E1 only.
  • What tool is best used in MS Excel Form for Gender (Male, Female)
    OptionButton.
  • Open MS Excel worksheet, and write a simple formula to list the first 10 even numbers.
    Your teacher will go over this question in MS Excel.
    • Your experience on this site will be improved by allowing cookies.