How do you display current date and time in MS Excel?


Options: date () B. Today () C. now () D. time ()

Ans:– C ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 9721 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


. Which of the following do you use to change margins?
Options: formatting toolbar B. page setup dialog box C. Standard toolbar D. paragraph dialog box

Ans: – B ,


. We can remove a relationship defined between two tables by
Options: a. From edit menu choose delete relationship b. Select the relationship line and press delete c. Choose delete option from relationship menu d. All of above

Ans:4 – b ,4 – b


What does RIPv2 use to prevent routing loops? CIDR Split horizon Authentication Classless masking Holddown timers
Options: 1 and 3,    2, 3 and 5,    2 and 5,    3 and 4

Ans:C ,C


If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Options: a. Press the Erase key b. Press Esc c. Press the Enter button d. Press the Edit Formula button

Ans:#8211; b,#8211; b


A proxy server is used for which of the following?
Options: To provide security against unauthorized users,    To process client requests for Web pages,    To process client requests for database access,    To provide TCP/IP

Ans:A ,A


. In which mode Windows starts with only the core drivers & services?
Options: Safe Mode B. Quick Mode       C. Normal Mode D. Repair Mode

Ans:– A ,


An excel workbook is a collection of
Options: a. Workbooks b. Worksheets c. Charts d. Worksheets and charts

Ans:#8211; d,#8211; d


Which two statements describe the IP address 10.16.3.65/23? The subnet address is 10.16.3.0 255.255.254.0. The lowest host address in the subnet is 10.16.2.1 255.255.254.0. The last valid host address in the subnet is 10.16.2.254 255.255.254.0. The broadcast address of the subnet is 10.16.3.255 255.255.254.0.
Options: 1 and 3,    2 and 4,    1, 2 and 4,    2, 3 and 4

Ans:B ,B


The data stored on a tape or disk file may be recorded in a report form described as
Options: a soft copy ledger,    printer spacing from,    proof listing,    All of the above

Ans:C ,C


How many bits can be stored in the 8K RAM?
Options: 8000,    8192,    4000,    4096

Ans:B ,B


. What will be the command if you want to copy rdoc file that resides in the floppy disk into work sub-directory of hard disk while you are in C prompt
Options: a. Copy c: doc a:work b. Copy A: doc c:work c. Copy rdoc c:work d. Copy c:>work a:doc

Ans:1 – b ,1 – b


A single transistor can be used to build which of the following digital logic gates?
Options: AND gates,    OR gates,    NOT gates,    NAND gates

Ans:C ,C


If digital data rate of 9600 bps is encoded using 8-level phase shift keying (PSK) method, the modulation rate is
Options: 1200 bands,    3200 bands,    4800 bands,    9600 bands

Ans:B ,B


The two major categories of software are: application software and
Options: system software,    UNIX software,    high-level languages,    CAD software

Ans:A ,A


. In Normal view, this tab displays the content of each slide.
Options: a. Slides b. View c. Sort d. Outline

Ans:0 – D ,0 – D


Which of the following command can you execute to count the number of lines in a file?
Options: lc,    wc - l,    cl,    count

Ans:B ,B


The extract process is which of the following?
Options: Capturing all of the data contained in various operational systems,    Capturing a subset of the data contained in various operational systems,    Capturing all of the data contained in various decision support systems,    Capturing a subset of the data contained in various decision support systems

Ans:B ,B


Which of the following provides a printed copy of your presentation?
Options: a. Outline b. Speaker notes c. Audience handouts d. All of the above

Ans: – C , – C


. Which of the following operating system does not implement the multitasking truly?
Options: a. Windows 98 b. Windows NT c. Windows XP d. MS DOS

Ans: d, d


Which symbol will be used with grep command to match the pattern pat at the end of a line?
Options: ^pat,    $pat,    pat$,    pat^

Ans:C ,C


Which is not necessary when using bar codes in supermarkets?
Options: Point-of sale (POS) terminal,    Check digit on the bar code,    Price on the shelf,    Price on the goods

Ans:C ,C


The main idea behind computer files is that it is convenient to
Options: arrange them,    store information together,    create them,    access them

Ans:B ,B


. Which is the highest form?
Options: A) Data B) Information C) Knowledge D) All of above

Ans:C,C


. Press _____ to create a line break, which advances the insertion point to the beginning of the next physical line – ignoring any paragraph formatting instructions.
Options: a. shift+enter b. ctrl+enter c. shift+tab d. ctrl+tab

Ans:– a,– a


. Which is the first electronic digital computer?
Options: A) ENIAC B) MARK I C) Z3 D) ABC

Ans:D,D


Which command is used to display and create files?
Options: cat,    vi,    ed,    lyrix

Ans:A ,A


Average inventory level is reduced by
Options: decreasing the vendor lead time,    increasing the usage rate,    decreasing the order quantity,    lowering the reorder point

Ans:C ,C


Where is metadata stored in MySQL?
Options: In the MySQL database metadata,    In the MySQL database metasql,    In the MySQL database mysql,    None of the above is correct.

Ans:C ,C


The disadvantages of "Compile and Go" loading scheme is (are):
Options: a portion of memory is wasted because the core occupied by the assembler is unavailable to the object program.,    it is necessary to retranslate the user's program deck every time it is run.,    it is very difficult to handle multiple segments, especially if the source programs are in different languages, and to produce orderly modular programs.,    all of the above

Ans:D ,D


If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options: 1NF.,    2NF.,    3NF.,    BCNF.

Ans:D ,D


A central purpose of most decision-support systems is
Options: to build a model of the decision¬making problem,    to design a data-base manage¬ment system,    to build an expert system,    to determine the key decisions in the problem area

Ans:A ,A


MS-EXCEL is based on ……….?
Options: WINDOWS B. DOS C. UNIX D. OS/2

Ans:– A ,


The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip. What is it called?
Options: Monochip,    Microprocessor,    ALU,    Control Unit

Ans:B ,B


A circular reference is
Options: a. Geometric modeling tool b. A cell that points to a drawing object c. A formula that either directly or indirectly depends on itself d. Always erroneous

Ans:#8211; c,#8211; c


Which command is used to remove a directory?
Options: rd,    rmdir,    dldir,    rdir

Ans:B ,B


. RD command are used to
Options: a. Remove an empty directory b. Remove non empty directory c. Remove directory including files d. None of the above

Ans:9 – a ,9 – a


How would you round off a value from 1.66 to 2.0?
Options: ceil(1.66),    floor(1.66),    roundup(1.66),    roundto(1.66)

Ans:A ,A


Computers built before the First Generation of computers were:
Options: Mechanical B. Electro-mechanical    C. Electrical D. None of these

Ans:– B ,


High-level languages:
Options: are "procedure-oriented",    are very difficult to use,    cannot be used with automatic systems.,    require knowledge of the computer design

Ans:A ,A


.   Which of the following you must first complete in order to delete an object?
Options: a. Double click the image b. Select the image c. Resize the image d. Move the image to a new location

Ans:6 – B ,6 – B


. The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
Options: a. Date b. Time c. Calendar d. Appointment

Ans:6 – a ,6 – a


One of the following is not considered a method of input control in a CAD system.
Options: Joystick,    Programmable function box,    Plotter,    Touch terminal

Ans:C ,C


. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
Options: a. cbo b. cob c. cmb d. cbx

Ans:3 – a ,3 – a


The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but the data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a linear array does not d. All of above

Ans: d, d


A word field may consist of an optional field instruction called a(n) ______ 
Options: a. subdocument b. symbol c. signal d. switch

Ans:–  D,–  D


All worksheet formula
Options: a. Manipulate values b. Manipulate labels c. Return a formula result d. Use the addition operator

Ans:#8211; c,#8211; c


The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: Data collection terminal,    OCR register terminal,    Video display terminal,    POS terminal

Ans:D,D


. The _____ function returns a string that has been converted to uppercase text.
Options: a. AllCap b. UCase c. UpCase d. Upper

Ans:2 – b ,2 – b


  A File which contains readymade styles that can be used for a presentation is called :
Options: AutoStyle B. Template C. Wizard D. Pre formatting

Ans:– B ,


. Which is not a valid file system?
Options: a. FAT 16 b. FAT 32 c. NTFS d. FXZ

Ans:5 – d ,5 – d

www.000webhost.com