Study

MS Excel Game 2

  •   0%
  •  0     0     0

  • What language did we use in MS Excel Programming/Coding
    VBA = Visual Basic for Applications
  • Name at least 1 tool used in VBA or MS Excel Programming/Coding
    CommandButton, OptionButton, CheckBox, Label, TextBox, ListBox, DropBox,..
  • 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.
  • List at least 2 functions or formulas we learned today in MS Excel.
    SUM,AVERAGE, MAX, MIN, COUNT, AVERAGE, LEN, ADDITION OPERATION, ...
  • 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.
  • 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 even numbers.
    Your teacher will go over this question in MS Excel.
  • 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 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.
  • What tool is best used in MS Excel Form for Gender (Male, Female)
    OptionButton.
  • 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 odd numbers.
    Your teacher will check your work.
  • 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.
  • Can you form ONE WORD with the following letters? T-E-E-H-S-K-R-O-W
    WORKSHEET
  • 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.